Pandas Profiling Report

Dataset statistics

Number of variables	34
Number of observations	81412
Missing cells	11149
Missing cells (%)	0.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	20.0 MiB
Average record size in memory	258.0 B

Variable types

Numeric	14
Categorical	14
Boolean	6

Alerts

`medical_specialty` has a high cardinality: 71 distinct values	High cardinality
`diag_1` has a high cardinality: 701 distinct values	High cardinality
`diag_2` has a high cardinality: 725 distinct values	High cardinality
`diag_3` has a high cardinality: 761 distinct values	High cardinality
`change` is highly correlated with `diabetesMed` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `change` and 1 other fields	High correlation
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`gender` is highly correlated with `hemoglobin_level`	High correlation
`age` is highly correlated with `medical_specialty`	High correlation
`admission_type_code` is highly correlated with `admission_source_code` and 1 other fields	High correlation
`admission_source_code` is highly correlated with `admission_type_code`	High correlation
`medical_specialty` is highly correlated with `age` and 1 other fields	High correlation
`hemoglobin_level` is highly correlated with `gender`	High correlation
`insulin` is highly correlated with `change` and 1 other fields	High correlation
`change` is highly correlated with `insulin` and 1 other fields	High correlation
`diabetesMed` is highly correlated with `insulin` and 1 other fields	High correlation
`age` has 2336 (2.9%) missing values	Missing
`weight` has 1560 (1.9%) missing values	Missing
`admission_type_code` has 1162 (1.4%) missing values	Missing
`num_lab_procedures` has 1493 (1.8%) missing values	Missing
`num_medications` has 2678 (3.3%) missing values	Missing
`diag_2` has 1349 (1.7%) missing values	Missing
`admission_id` is uniformly distributed	Uniform
`admission_id` has unique values	Unique
`num_procedures` has 37355 (45.9%) zeros	Zeros
`number_outpatient` has 67984 (83.5%) zeros	Zeros
`number_emergency` has 72350 (88.9%) zeros	Zeros
`number_inpatient` has 53995 (66.3%) zeros	Zeros

Reproduction

Analysis started	2022-02-01 17:22:29.832680
Analysis finished	2022-02-01 17:23:27.469446
Duration	57.64 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

admission_id
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	81412
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40705.5

Minimum	0
Maximum	81411
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	0
5-th percentile	4070.55
Q1	20352.75
median	40705.5
Q3	61058.25
95-th percentile	77340.45
Maximum	81411
Range	81411
Interquartile range (IQR)	40705.5

Descriptive statistics

Standard deviation	23501.76439
Coefficient of variation (CV)	0.5773609069
Kurtosis	-1.2
Mean	40705.5
Median Absolute Deviation (MAD)	20353
Skewness	0
Sum	3313916166
Variance	552332929.7
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
79180	1	< 0.1%
19811	1	< 0.1%
17762	1	< 0.1%
23905	1	< 0.1%
21856	1	< 0.1%
77135	1	< 0.1%
75086	1	< 0.1%
81229	1	< 0.1%
68939	1	< 0.1%
Other values (81402)	81402	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
81411	1	< 0.1%
81410	1	< 0.1%
81409	1	< 0.1%
81408	1	< 0.1%
81407	1	< 0.1%
81406	1	< 0.1%
81405	1	< 0.1%
81404	1	< 0.1%
81403	1	< 0.1%
81402	1	< 0.1%

patient_id
Real number (ℝ_≥0)

Distinct	60069
Distinct (%)	73.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108639531.1

Minimum	198
Maximum	379005166
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	198
5-th percentile	2914233.3
Q1	46839060
median	90834372
Q3	175111722
95-th percentile	222996661.2
Maximum	379005166
Range	379004968
Interquartile range (IQR)	128272662

Descriptive statistics

Standard deviation	77324533.16
Coefficient of variation (CV)	0.7117531928
Kurtosis	-0.3648068986
Mean	108639531.1
Median Absolute Deviation (MAD)	65849112
Skewness	0.4666683655
Sum	8.844561509 × 10¹²
Variance	5.979083428 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
177571710	33	< 0.1%
176455008	20	< 0.1%
181219536	19	< 0.1%
185418630	18	< 0.1%
47286738	18	< 0.1%
3320514	18	< 0.1%
182320488	17	< 0.1%
46397970	17	< 0.1%
86281740	16	< 0.1%
168857154	16	< 0.1%
Other values (60059)	81220	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
198	2	< 0.1%
684	1	< 0.1%
1386	1	< 0.1%
1476	1	< 0.1%
1782	1	< 0.1%
2232	4	< 0.1%
2538	1	< 0.1%
2556	3	< 0.1%
3186	1	< 0.1%
3978	1	< 0.1%

Value	Count	Frequency (%)
379005166	1	< 0.1%
378702118	1	< 0.1%
378698788	1	< 0.1%
378664102	1	< 0.1%
378515620	1	< 0.1%
378431452	1	< 0.1%
378358570	1	< 0.1%
378258634	1	< 0.1%
378194590	1	< 0.1%
378151156	1	< 0.1%

race
Categorical

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

Caucasian	48733
AfricanAmerican	9209
White	6015
African American	3067
WHITE	3047
Other values (10)	11341

Length

Max length	16
Median length	9
Mean length	9.144622414
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Caucasian
2nd row	Caucasian
3rd row	EURO
4th row	Black
5th row	Caucasian

Common Values

Value	Count	Frequency (%)
Caucasian	48733	59.9%
AfricanAmerican	9209	11.3%
White	6015	7.4%
African American	3067	3.8%
WHITE	3047	3.7%
European	2491	3.1%
?	1827	2.2%
Black	1545	1.9%
Afro American	1411	1.7%
Hispanic	1305	1.6%
Other values (5)	2762	3.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
caucasian	48733	56.7%
africanamerican	9365	10.9%
white	9062	10.6%
american	4478	5.2%
african	3067	3.6%
european	2491	2.9%
	1827	2.1%
black	1545	1.8%
afro	1411	1.6%
hispanic	1305	1.5%
Other values (4)	2606	3.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

gender
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

Female	43719
Male	37691
Unknown/Invalid	2

Length

Max length	15
Median length	6
Mean length	5.074288803
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Male
3rd row	Female
4th row	Female
5th row	Female

Common Values

Value	Count	Frequency (%)
Female	43719	53.7%
Male	37691	46.3%
Unknown/Invalid	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
female	43719	53.7%
male	37691	46.3%
unknown/invalid	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

age
Categorical

HIGH CORRELATION
MISSING

Distinct	10
Distinct (%)	< 0.1%
Missing	2336
Missing (%)	2.9%
Memory size	636.2 KiB

[70-80)	20261
[60-70)	17414
[50-60)	13414
[80-90)	13383
[40-50)	7498
Other values (5)	7106

Length

Max length	8
Median length	7
Mean length	7.025747382
Min length	6

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	[50-60)
2nd row	[80-90)
3rd row	[60-70)
4th row	[70-80)
5th row	[70-80)

Common Values

Value	Count	Frequency (%)
[70-80)	20261	24.9%
[60-70)	17414	21.4%
[50-60)	13414	16.5%
[80-90)	13383	16.4%
[40-50)	7498	9.2%
[30-40)	2964	3.6%
[90-100)	2172	2.7%
[20-30)	1297	1.6%
[10-20)	537	0.7%
[0-10)	136	0.2%
(Missing)	2336	2.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
70-80	20261	25.6%
60-70	17414	22.0%
50-60	13414	17.0%
80-90	13383	16.9%
40-50	7498	9.5%
30-40	2964	3.7%
90-100	2172	2.7%
20-30	1297	1.6%
10-20	537	0.7%
0-10	136	0.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

weight
Categorical

MISSING

Distinct	10
Distinct (%)	< 0.1%
Missing	1560
Missing (%)	1.9%
Memory size	636.2 KiB

?	77353
[75-100)	1037
[50-75)	713
[100-125)	482
[125-150)	117
Other values (5)	150

Length

Max length	9
Median length	1
Mean length	1.216024646
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	?
2nd row	?
3rd row	?
4th row	?
5th row	?

Common Values

Value	Count	Frequency (%)
?	77353	95.0%
[75-100)	1037	1.3%
[50-75)	713	0.9%
[100-125)	482	0.6%
[125-150)	117	0.1%
[25-50)	72	0.1%
[0-25)	40	< 0.1%
[150-175)	27	< 0.1%
[175-200)	8	< 0.1%
>200	3	< 0.1%
(Missing)	1560	1.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
	77353	96.9%
75-100	1037	1.3%
50-75	713	0.9%
100-125	482	0.6%
125-150	117	0.1%
25-50	72	0.1%
0-25	40	0.1%
150-175	27	< 0.1%
175-200	8	< 0.1%
200	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

admission_type_code
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	1162
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	2.024598131

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	8
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.44601519
Coefficient of variation (CV)	0.7142233155
Kurtosis	1.942273762
Mean	2.024598131
Median Absolute Deviation (MAD)	0
Skewness	1.591920787
Sum	162474
Variance	2.090959928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	42562	52.3%
3	14884	18.3%
2	14576	17.9%
6	4182	5.1%
5	3768	4.6%
8	254	0.3%
7	16	< 0.1%
4	8	< 0.1%
(Missing)	1162	1.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	42562	52.3%
2	14576	17.9%
3	14884	18.3%
4	8	< 0.1%
5	3768	4.6%
6	4182	5.1%
7	16	< 0.1%
8	254	0.3%

Value	Count	Frequency (%)
8	254	0.3%
7	16	< 0.1%
6	4182	5.1%
5	3768	4.6%
4	8	< 0.1%
3	14884	18.3%
2	14576	17.9%
1	42562	52.3%

discharge_disposition_code
Real number (ℝ_≥0)

Distinct	25
Distinct (%)	< 0.1%
Missing	571
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	3.711260375

Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	18
Maximum	28
Range	27
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	5.273755472
Coefficient of variation (CV)	1.421014679
Kurtosis	6.031098616
Mean	3.711260375
Median Absolute Deviation (MAD)	0
Skewness	2.567316037
Sum	300022
Variance	27.81249678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	47854	58.8%
3	11097	13.6%
6	10244	12.6%
18	2912	3.6%
2	1690	2.1%
22	1580	1.9%
11	1312	1.6%
5	936	1.1%
25	793	1.0%
4	650	0.8%
Other values (15)	1773	2.2%
(Missing)	571	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	47854	58.8%
2	1690	2.1%
3	11097	13.6%
4	650	0.8%
5	936	1.1%
6	10244	12.6%
7	506	0.6%
8	85	0.1%
9	18	< 0.1%
10	5	< 0.1%

Value	Count	Frequency (%)
28	106	0.1%
27	4	< 0.1%
25	793	1.0%
24	40	< 0.1%
23	324	0.4%
22	1580	1.9%
19	5	< 0.1%
18	2912	3.6%
17	12	< 0.1%
16	7	< 0.1%

admission_source_code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.750122832

Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	7
Q3	7
95-th percentile	17
Maximum	25
Range	24
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.063455702
Coefficient of variation (CV)	0.7066728521
Kurtosis	1.749926677
Mean	5.750122832
Median Absolute Deviation (MAD)	0
Skewness	1.031186893
Sum	468129
Variance	16.51167224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
7	45942	56.4%
1	23684	29.1%
17	5412	6.6%
4	2581	3.2%
6	1819	2.2%
2	878	1.1%
5	681	0.8%
3	148	0.2%
20	130	0.2%
9	99	0.1%
Other values (7)	38	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	23684	29.1%
2	878	1.1%
3	148	0.2%
4	2581	3.2%
5	681	0.8%
6	1819	2.2%
7	45942	56.4%
8	15	< 0.1%
9	99	0.1%
10	6	< 0.1%

Value	Count	Frequency (%)
25	2	< 0.1%
22	10	< 0.1%
20	130	0.2%
17	5412	6.6%
14	2	< 0.1%
13	1	< 0.1%
11	2	< 0.1%
10	6	< 0.1%
9	99	0.1%
8	15	< 0.1%

time_in_hospital
Real number (ℝ_≥0)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.395924434

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	11
Maximum	14
Range	13
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.975844099
Coefficient of variation (CV)	0.6769552444
Kurtosis	0.8490950317
Mean	4.395924434
Median Absolute Deviation (MAD)	2
Skewness	1.130728188
Sum	357881
Variance	8.855648103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
3	14223	17.5%
2	13723	16.9%
1	11302	13.9%
4	11228	13.8%
5	7975	9.8%
6	6059	7.4%
7	4717	5.8%
8	3528	4.3%
9	2372	2.9%
10	1886	2.3%
Other values (4)	4399	5.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	11302	13.9%
2	13723	16.9%
3	14223	17.5%
4	11228	13.8%
5	7975	9.8%
6	6059	7.4%
7	4717	5.8%
8	3528	4.3%
9	2372	2.9%
10	1886	2.3%

Value	Count	Frequency (%)
14	814	1.0%
13	944	1.2%
12	1153	1.4%
11	1488	1.8%
10	1886	2.3%
9	2372	2.9%
8	3528	4.3%
7	4717	5.8%
6	6059	7.4%
5	7975	9.8%

payer_code
Categorical

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

?	32278
MC	25952
HM	4973
SP	4003
BC	3718
Other values (13)	10488

Length

Max length	2
Median length	2
Mean length	1.603522822
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	?
2nd row	MC
3rd row	MD
4th row	?
5th row	MC

Common Values

Value	Count	Frequency (%)
?	32278	39.6%
MC	25952	31.9%
HM	4973	6.1%
SP	4003	4.9%
BC	3718	4.6%
MD	2824	3.5%
CP	2053	2.5%
UN	1925	2.4%
CM	1551	1.9%
OG	795	1.0%
Other values (8)	1340	1.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	32278	39.6%
mc	25952	31.9%
hm	4973	6.1%
sp	4003	4.9%
bc	3718	4.6%
md	2824	3.5%
cp	2053	2.5%
un	1925	2.4%
cm	1551	1.9%
og	795	1.0%
Other values (8)	1340	1.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

medical_specialty
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	71
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

?	40020
InternalMedicine	11712
Emergency/Trauma	6021
Family/GeneralPractice	5939
Cardiology	4273
Other values (66)	13447

Length

Max length	36
Median length	8
Mean length	8.599199135
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	?
2nd row	Emergency/Trauma
3rd row	?
4th row	?
5th row	?

Common Values

Value	Count	Frequency (%)
?	40020	49.2%
InternalMedicine	11712	14.4%
Emergency/Trauma	6021	7.4%
Family/GeneralPractice	5939	7.3%
Cardiology	4273	5.2%
Surgery-General	2473	3.0%
Nephrology	1299	1.6%
Orthopedics	1100	1.4%
Orthopedics-Reconstructive	981	1.2%
Radiologist	913	1.1%
Other values (61)	6681	8.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	40020	49.2%
internalmedicine	11712	14.4%
emergency/trauma	6021	7.4%
family/generalpractice	5939	7.3%
cardiology	4273	5.2%
surgery-general	2473	3.0%
nephrology	1299	1.6%
orthopedics	1100	1.4%
orthopedics-reconstructive	981	1.2%
radiologist	913	1.1%
Other values (61)	6681	8.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

has_prosthesis
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.6 KiB

False	80550
True	862

Common Values
Chart

Value	Count	Frequency (%)
False	80550	98.9%
True	862	1.1%

complete_vaccination_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

Complete	67114
Incomplete	13978
None	320

Length

Max length	10
Median length	8
Mean length	8.327666683
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Complete
2nd row	Complete
3rd row	Complete
4th row	Complete
5th row	Complete

Common Values

Value	Count	Frequency (%)
Complete	67114	82.4%
Incomplete	13978	17.2%
None	320	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
complete	67114	82.4%
incomplete	13978	17.2%
none	320	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

num_lab_procedures
Real number (ℝ_≥0)

MISSING

Distinct	115
Distinct (%)	0.1%
Missing	1493
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	43.07119709

Minimum	1
Maximum	132
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	32
median	44
Q3	57
95-th percentile	73
Maximum	132
Range	131
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	19.63040493
Coefficient of variation (CV)	0.4557664114
Kurtosis	-0.2441755168
Mean	43.07119709
Median Absolute Deviation (MAD)	13
Skewness	-0.2404533528
Sum	3442207
Variance	385.3527977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2533	3.1%
43	2207	2.7%
44	1988	2.4%
45	1884	2.3%
38	1764	2.2%
40	1736	2.1%
46	1720	2.1%
41	1718	2.1%
47	1679	2.1%
39	1662	2.0%
Other values (105)	61028	75.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2533	3.1%
2	858	1.1%
3	523	0.6%
4	285	0.4%
5	231	0.3%
6	214	0.3%
7	258	0.3%
8	281	0.3%
9	728	0.9%
10	655	0.8%

Value	Count	Frequency (%)
132	1	< 0.1%
126	1	< 0.1%
121	1	< 0.1%
118	1	< 0.1%
114	2	< 0.1%
113	1	< 0.1%
111	2	< 0.1%
109	3	< 0.1%
108	3	< 0.1%
106	4	< 0.1%

num_procedures
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.341767798

Minimum	0
Maximum	6
Zeros	37355
Zeros (%)	45.9%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.708464781
Coefficient of variation (CV)	1.273293921
Kurtosis	0.8445664498
Mean	1.341767798
Median Absolute Deviation (MAD)	1
Skewness	1.313355194
Sum	109236
Variance	2.918851909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	37355	45.9%
1	16513	20.3%
2	10162	12.5%
3	7548	9.3%
6	3994	4.9%
4	3409	4.2%
5	2431	3.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37355	45.9%
1	16513	20.3%
2	10162	12.5%
3	7548	9.3%
4	3409	4.2%
5	2431	3.0%
6	3994	4.9%

Value	Count	Frequency (%)
6	3994	4.9%
5	2431	3.0%
4	3409	4.2%
3	7548	9.3%
2	10162	12.5%
1	16513	20.3%
0	37355	45.9%

num_medications
Real number (ℝ_≥0)

MISSING

Distinct	73
Distinct (%)	0.1%
Missing	2678
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%
Mean	16.02442401

Minimum	1
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	10
median	15
Q3	20
95-th percentile	31
Maximum	81
Range	80
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.107234783
Coefficient of variation (CV)	0.5059298717
Kurtosis	3.427614554
Mean	16.02442401
Median Absolute Deviation (MAD)	5
Skewness	1.316139858
Sum	1261667
Variance	65.72725582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	4714	5.8%
12	4636	5.7%
11	4457	5.5%
15	4443	5.5%
14	4436	5.4%
16	4234	5.2%
10	4108	5.0%
17	3817	4.7%
9	3813	4.7%
18	3523	4.3%
Other values (63)	36553	44.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	203	0.2%
2	357	0.4%
3	687	0.8%
4	1107	1.4%
5	1570	1.9%
6	2094	2.6%
7	2662	3.3%
8	3356	4.1%
9	3813	4.7%
10	4108	5.0%

Value	Count	Frequency (%)
81	1	< 0.1%
75	2	< 0.1%
74	1	< 0.1%
70	2	< 0.1%
69	5	< 0.1%
68	6	< 0.1%
67	6	< 0.1%
66	3	< 0.1%
65	8	< 0.1%
64	7	< 0.1%

number_outpatient
Real number (ℝ_≥0)

ZEROS

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3709526851

Minimum	0
Maximum	42
Zeros	67984
Zeros (%)	83.5%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	42
Range	42
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.278537861
Coefficient of variation (CV)	3.446633256
Kurtosis	152.4729964
Mean	0.3709526851
Median Absolute Deviation (MAD)	0
Skewness	8.984331589
Sum	30200
Variance	1.634659062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
0	67984	83.5%
1	6862	8.4%
2	2904	3.6%
3	1618	2.0%
4	873	1.1%
5	420	0.5%
6	238	0.3%
7	129	0.2%
8	76	0.1%
9	73	0.1%
Other values (29)	235	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	67984	83.5%
1	6862	8.4%
2	2904	3.6%
3	1618	2.0%
4	873	1.1%
5	420	0.5%
6	238	0.3%
7	129	0.2%
8	76	0.1%
9	73	0.1%

Value	Count	Frequency (%)
42	1	< 0.1%
40	1	< 0.1%
39	1	< 0.1%
38	1	< 0.1%
37	1	< 0.1%
36	1	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	2	< 0.1%
29	2	< 0.1%

number_emergency
Real number (ℝ_≥0)

ZEROS

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1975875792

Minimum	0
Maximum	64
Zeros	72350
Zeros (%)	88.9%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	64
Range	64
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8812896989
Coefficient of variation (CV)	4.460248475
Kurtosis	638.5493694
Mean	0.1975875792
Median Absolute Deviation (MAD)	0
Skewness	16.40885167
Sum	16086
Variance	0.7766715333
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	72350	88.9%
1	6064	7.4%
2	1646	2.0%
3	588	0.7%
4	292	0.4%
5	167	0.2%
6	82	0.1%
7	55	0.1%
8	39	< 0.1%
9	27	< 0.1%
Other values (19)	102	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	72350	88.9%
1	6064	7.4%
2	1646	2.0%
3	588	0.7%
4	292	0.4%
5	167	0.2%
6	82	0.1%
7	55	0.1%
8	39	< 0.1%
9	27	< 0.1%

Value	Count	Frequency (%)
64	1	< 0.1%
46	1	< 0.1%
42	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
25	2	< 0.1%
24	1	< 0.1%
22	4	< 0.1%
21	2	< 0.1%
20	4	< 0.1%

number_inpatient
Real number (ℝ_≥0)

ZEROS

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6377929544

Minimum	0
Maximum	21
Zeros	53995
Zeros (%)	66.3%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	21
Range	21
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.265472414
Coefficient of variation (CV)	1.984142981
Kurtosis	20.83213029
Mean	0.6377929544
Median Absolute Deviation (MAD)	0
Skewness	3.619760625
Sum	51924
Variance	1.60142043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	53995	66.3%
1	15706	19.3%
2	6057	7.4%
3	2747	3.4%
4	1288	1.6%
5	641	0.8%
6	386	0.5%
7	224	0.3%
8	120	0.1%
9	93	0.1%
Other values (11)	155	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	53995	66.3%
1	15706	19.3%
2	6057	7.4%
3	2747	3.4%
4	1288	1.6%
5	641	0.8%
6	386	0.5%
7	224	0.3%
8	120	0.1%
9	93	0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
19	2	< 0.1%
18	1	< 0.1%
17	1	< 0.1%
16	4	< 0.1%
15	7	< 0.1%
14	6	< 0.1%
13	16	< 0.1%
12	30	< 0.1%
11	40	< 0.1%

diag_1
Categorical

HIGH CARDINALITY

Distinct	701
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

428	5429
414	5270
786	3232
410	2914
486	2776
Other values (696)	61791

Length

Max length	6
Median length	3
Mean length	3.17798359
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	84 ?
Unique (%)	0.1%

Sample

1st row	721
2nd row	276
3rd row	414
4th row	577
5th row	531

Common Values

Value	Count	Frequency (%)
428	5429	6.7%
414	5270	6.5%
786	3232	4.0%
410	2914	3.6%
486	2776	3.4%
427	2218	2.7%
491	1811	2.2%
715	1691	2.1%
780	1620	2.0%
682	1612	2.0%
Other values (691)	52839	64.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
428	5429	6.7%
414	5270	6.5%
786	3232	4.0%
410	2914	3.6%
486	2776	3.4%
427	2218	2.7%
491	1811	2.2%
715	1691	2.1%
780	1620	2.0%
682	1612	2.0%
Other values (691)	52839	64.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diag_2
Categorical

HIGH CARDINALITY
MISSING

Distinct	725
Distinct (%)	0.9%
Missing	1349
Missing (%)	1.7%
Memory size	636.2 KiB

276	5296
428	5234
250	4778
427	3949
401	2906
Other values (720)	57900

Length

Max length	6
Median length	3
Mean length	3.166931042
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	126 ?
Unique (%)	0.2%

Sample

1st row	250.6
2nd row	507
3rd row	490
4th row	585
5th row	532

Common Values

Value	Count	Frequency (%)
276	5296	6.5%
428	5234	6.4%
250	4778	5.9%
427	3949	4.9%
401	2906	3.6%
496	2626	3.2%
599	2604	3.2%
403	2252	2.8%
414	2076	2.5%
411	2019	2.5%
Other values (715)	46323	56.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
276	5296	6.6%
428	5234	6.5%
250	4778	6.0%
427	3949	4.9%
401	2906	3.6%
496	2626	3.3%
599	2604	3.3%
403	2252	2.8%
414	2076	2.6%
411	2019	2.5%
Other values (715)	46323	57.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diag_3
Categorical

HIGH CARDINALITY

Distinct	761
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

250	9166
401	6606
276	4112
428	3734
427	3156
Other values (756)	54638

Length

Max length	6
Median length	3
Mean length	3.111678868
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	114 ?
Unique (%)	0.1%

Sample

1st row	357
2nd row	150
3rd row	250
4th row	250
5th row	562

Common Values

Value	Count	Frequency (%)
250	9166	11.3%
401	6606	8.1%
276	4112	5.1%
428	3734	4.6%
427	3156	3.9%
414	2938	3.6%
496	2090	2.6%
403	1886	2.3%
585	1621	2.0%
272	1605	2.0%
Other values (751)	44498	54.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
250	9166	11.3%
401	6606	8.1%
276	4112	5.1%
428	3734	4.6%
427	3156	3.9%
414	2938	3.6%
496	2090	2.6%
403	1886	2.3%
585	1621	2.0%
272	1605	2.0%
Other values (751)	44498	54.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

number_diagnoses
Real number (ℝ_≥0)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.421964821

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	6
median	8
Q3	9
95-th percentile	9
Maximum	16
Range	15
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.931480463
Coefficient of variation (CV)	0.2602384287
Kurtosis	-0.07655270384
Mean	7.421964821
Median Absolute Deviation (MAD)	1
Skewness	-0.8713996895
Sum	604237
Variance	3.730616778
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
9	39501	48.5%
5	9144	11.2%
8	8506	10.4%
7	8379	10.3%
6	8133	10.0%
4	4428	5.4%
3	2238	2.7%
2	824	1.0%
1	167	0.2%
16	38	< 0.1%
Other values (6)	54	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	167	0.2%
2	824	1.0%
3	2238	2.7%
4	4428	5.4%
5	9144	11.2%
6	8133	10.0%
7	8379	10.3%
8	8506	10.4%
9	39501	48.5%
10	14	< 0.1%

Value	Count	Frequency (%)
16	38	< 0.1%
15	8	< 0.1%
14	5	< 0.1%
13	14	< 0.1%
12	5	< 0.1%
11	8	< 0.1%
10	14	< 0.1%
9	39501	48.5%
8	8506	10.4%
7	8379	10.3%

blood_type
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

O+	32053
A+	24744
B+	9218
O-	5689
A-	4826
Other values (3)	4882

Length

Max length	3
Median length	2
Mean length	2.041738319
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A+
2nd row	B+
3rd row	O+
4th row	AB-
5th row	A+

Common Values

Value	Count	Frequency (%)
O+	32053	39.4%
A+	24744	30.4%
B+	9218	11.3%
O-	5689	7.0%
A-	4826	5.9%
AB+	2619	3.2%
B-	1484	1.8%
AB-	779	1.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
o	37742	46.4%
a	29570	36.3%
b	10702	13.1%
ab	3398	4.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

hemoglobin_level
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	77
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.19232791

Minimum	10.5
Maximum	18.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	636.2 KiB

Quantile statistics

Minimum	10.5
5-th percentile	12.6
Q1	13.4
median	14.1
Q3	15
95-th percentile	16
Maximum	18.6
Range	8.1
Interquartile range (IQR)	1.6

Descriptive statistics

Standard deviation	1.059999933
Coefficient of variation (CV)	0.07468823574
Kurtosis	-0.4492654524
Mean	14.19232791
Median Absolute Deviation (MAD)	0.8
Skewness	0.1878605037
Sum	1155425.8
Variance	1.123599858
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.6	2964	3.6%
13.9	2911	3.6%
13.7	2876	3.5%
13.8	2841	3.5%
13.5	2796	3.4%
14.1	2745	3.4%
14	2730	3.4%
14.2	2657	3.3%
13.4	2654	3.3%
13.3	2643	3.2%
Other values (67)	53595	65.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10.5	2	< 0.1%
10.8	2	< 0.1%
10.9	3	< 0.1%
11	5	< 0.1%
11.1	3	< 0.1%
11.2	18	< 0.1%
11.3	17	< 0.1%
11.4	33	< 0.1%
11.5	47	0.1%
11.6	71	0.1%

Value	Count	Frequency (%)
18.6	1	< 0.1%
18.2	2	< 0.1%
18.1	2	< 0.1%
18	1	< 0.1%
17.9	2	< 0.1%
17.8	2	< 0.1%
17.7	2	< 0.1%
17.6	7	< 0.1%
17.5	16	< 0.1%
17.4	32	< 0.1%

blood_transfusion
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.6 KiB

False	71697
True	9715

Common Values
Chart

Value	Count	Frequency (%)
False	71697	88.1%
True	9715	11.9%

max_glu_serum
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

None	54061
NONE	23098
Norm	1207
>200	1179
>300	1025

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	NONE
4th row	NONE
5th row	None

Common Values

Value	Count	Frequency (%)
None	54061	66.4%
NONE	23098	28.4%
Norm	1207	1.5%
>200	1179	1.4%
>300	1025	1.3%
NORM	842	1.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
none	77159	94.8%
norm	2049	2.5%
200	1179	1.4%
300	1025	1.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

A1Cresult
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

None	67807
>8	6547
Norm	4003
>7	3055

Length

Max length	4
Median length	4
Mean length	3.764113399
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	>7
3rd row	None
4th row	>8
5th row	None

Common Values

Value	Count	Frequency (%)
None	67807	83.3%
>8	6547	8.0%
Norm	4003	4.9%
>7	3055	3.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
none	67807	83.3%
8	6547	8.0%
norm	4003	4.9%
7	3055	3.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diuretics
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.6 KiB

False	79893
True	1519

Common Values
Chart

Value	Count	Frequency (%)
False	79893	98.1%
True	1519	1.9%

insulin
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.6 KiB

True	44360
False	37052

Common Values
Chart

Value	Count	Frequency (%)
True	44360	54.5%
False	37052	45.5%

change
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	636.2 KiB

No	43772
Ch	37640

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	Ch
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	43772	53.8%
Ch	37640	46.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
no	43772	53.8%
ch	37640	46.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

diabetesMed
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.6 KiB

True	62718
False	18694

Common Values
Chart

Value	Count	Frequency (%)
True	62718	77.0%
False	18694	23.0%

readmitted
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.6 KiB

False	72340
True	9072

Common Values
Chart

Value	Count	Frequency (%)
False	72340	88.9%
True	9072	11.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	admission_id	patient_id	race	gender	age	weight	admission_type_code	discharge_disposition_code	admission_source_code	time_in_hospital	payer_code	medical_specialty	has_prosthesis	complete_vaccination_status	num_lab_procedures	num_procedures	num_medications	number_outpatient	number_emergency	number_inpatient	diag_1	diag_2	diag_3	number_diagnoses	blood_type	hemoglobin_level	blood_transfusion	max_glu_serum	A1Cresult	diuretics	insulin	change	diabetesMed	readmitted
0	0	199042938	Caucasian	Male	[50-60)	?	3.0	1.0	1	1	?	?	False	Complete	24.0	3	9.0	0	0	0	721	250.6	357	5	A+	14.5	False	None	None	No	No	No	Yes	No
1	1	91962954	Caucasian	Male	[80-90)	?	2.0	1.0	7	3	MC	Emergency/Trauma	False	Complete	50.0	0	8.0	0	0	1	276	507	150	9	B+	15.7	False	None	>7	No	No	No	No	Yes
2	2	109707084	EURO	Female	[60-70)	?	1.0	1.0	7	5	MD	?	False	Complete	43.0	6	28.0	0	0	0	414	490	250	6	O+	13.0	False	NONE	None	No	Yes	Ch	Yes	No
3	3	157495374	Black	Female	[70-80)	?	6.0	1.0	17	2	?	?	False	Complete	58.0	5	8.0	0	1	1	577	585	250	9	AB-	13.5	False	NONE	>8	No	No	No	Yes	No
4	4	82692360	Caucasian	Female	NaN	?	1.0	22.0	7	12	MC	?	False	Complete	56.0	1	16.0	0	0	2	531	532	562	8	A+	13.0	False	None	None	No	No	No	No	No
5	5	218016576	Caucasian	Female	[70-80)	?	2.0	1.0	1	4	HM	?	False	Incomplete	14.0	3	13.0	0	0	0	578	280	562	9	A+	13.1	False	None	None	No	No	No	Yes	Yes
6	6	143084970	Caucasian	Male	[60-70)	?	1.0	1.0	7	6	BC	?	False	Complete	62.0	0	21.0	0	0	0	482	428	276	9	A-	14.2	False	None	>7	No	Yes	No	Yes	No
7	7	227644092	Other	Female	[70-80)	?	3.0	1.0	1	11	?	InternalMedicine	False	Incomplete	18.0	4	9.0	1	0	1	V57	438	599	6	O+	12.9	False	NONE	None	No	No	No	No	No
8	8	77740434	Caucasian	Female	[70-80)	?	1.0	3.0	7	2	MC	?	False	Complete	36.0	0	9.0	0	0	3	250.8	682	496	6	O-	13.9	False	NONE	None	No	Yes	No	Yes	No
9	9	203123016	WHITE	Female	[40-50)	?	3.0	1.0	1	2	?	?	False	Complete	5.0	2	25.0	0	0	0	433	362	401	9	A+	13.2	False	NONE	None	No	Yes	Ch	Yes	No

Last rows

	admission_id	patient_id	race	gender	age	weight	admission_type_code	discharge_disposition_code	admission_source_code	time_in_hospital	payer_code	medical_specialty	has_prosthesis	complete_vaccination_status	num_lab_procedures	num_procedures	num_medications	number_emergency	number_inpatient	diag_1	diag_2	diag_3	number_diagnoses	blood_type	hemoglobin_level	blood_transfusion	max_glu_serum	A1Cresult	diuretics	insulin	change	diabetesMed	readmitted
81402	81402	155324556	Other	Male	[50-60)	?	1.0	1.0	7	3	MD	?	False	Incomplete	1.0	0	13.0	0	0	682	250.82	707	9	O+	16.7	False	None	None	No	Yes	No	Yes	No
81403	81403	224478630	AfricanAmerican	Female	[80-90)	?	3.0	6.0	2	7	?	?	False	Complete	35.0	2	37.0	2	0	440	707	401	4	A+	13.8	False	None	None	No	Yes	Ch	Yes	Yes
81404	81404	228104460	AfricanAmerican	Female	[50-60)	?	3.0	1.0	1	3	?	ObstetricsandGynecology	False	Complete	8.0	2	12.0	0	0	218	218	626	9	AB-	12.8	False	None	None	No	No	No	Yes	No
81405	81405	48436146	Black	Female	[40-50)	?	1.0	1.0	7	6	MC	Nephrology	False	Incomplete	35.0	3	22.0	0	0	595	591	V45	9	B+	11.4	False	None	None	No	Yes	No	Yes	No
81406	81406	91915884	Caucasian	Female	[80-90)	?	1.0	3.0	7	4	MD	?	False	Complete	46.0	0	11.0	0	0	584	276	272	9	A+	13.8	False	NONE	None	No	Yes	No	Yes	No
81407	81407	80746578	Caucasian	Male	[60-70)	?	1.0	24.0	7	2	MD	?	False	Complete	64.0	0	22.0	0	3	486	496	250.92	5	O+	15.4	False	None	None	No	Yes	Ch	Yes	No
81408	81408	221853996	AFRICANAMERICAN	Female	[70-80)	?	1.0	6.0	7	8	CP	InternalMedicine	False	Complete	62.0	2	19.0	0	1	440	401	276	9	O+	12.8	False	None	None	No	Yes	Ch	Yes	No
81409	81409	104846580	Black	Female	[60-70)	?	1.0	22.0	7	5	?	?	False	Complete	1.0	2	14.0	0	0	822	403	250.6	9	B+	13.0	False	None	None	No	No	No	No	Yes
81410	81410	229820346	Caucasian	Female	[50-60)	?	3.0	1.0	2	1	?	?	False	Complete	30.0	1	10.0	0	0	996	753	250	7	AB+	13.3	True	None	None	No	No	No	Yes	No
81411	81411	49302180	African American	Female	[40-50)	?	1.0	1.0	7	3	?	InternalMedicine	False	Complete	43.0	0	14.0	0	0	250.12	198	V10	4	B+	12.4	False	None	None	No	Yes	Ch	Yes	No

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length